{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["StartHere","5.ID","Financial information ","SI and regression Pt 1","Current operations Pt2 & Pt3 ","Franchise operations Pt2 & Pt3","Expected Values Pt3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"StartHere","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,2,10,2],[11,2,12,2]]}
[]
[null,"Student Identification Sheet (version5.2)"]
[]
[null,"Name","Dallan Delgado"," <<- enter your name here",null,null,"(1)","Add your name to Cell C4 and your Student ID to cell C6. Then  Click [Start Here] to finish loading data."]
[null,null,null,null,null,null,"(2)","Change the file name to include your name. "]
[null,"Student ID","002-46-2565"," <<- enter your Student ID here",null,null,"(3)","When done with your work, Click [I'm Done]"]
[null,null,null,null,null,null,"(3)","Upload the file to the applicable iCollege"]
[null,"Date/time",{"$f":"NOW()","v":"2021-04-03T13:52:56.250"},null,null,null,null," assignment folder to receive credit for this workshop/tutorial"]
[null,null,"Spring 2021",null,null,null,"(4)","Never use a file created or started by another student (that is academic dishonesty).\nAll text, codes, writing, data entry, formulas, configuration and instructions must be performed by the individual submitting the work."]
[null,null,"You must use Excel Desktop. Cloud Excel 365 will not work for this class.",null,"2021-03-10T13:45:02.740","Dallan Delgado started S01"]
[]
[null,null,"Collaboration Started"]
[]
[null,null,"Individual Challenge started"]
[null,null,"Kurt Schmitz © 2020 Do not post or reproduce."]
[]
[null,"Excel release",{"$f":"INFO(\"release\")","v":"16.47"},"<< Mac Users below 16.24, please update!"]
[null,"OS",{"$f":"INFO(\"OSVERSION\")","v":"Macintosh (Intel) Version 11.0.1 (Build 20B29)"},"<< Windows users with version 16.0 are good to go."]

{"sheet":"5.ID","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Do Not Alter or Delete this Worksheet or you submission cannot be graded!",null,null,null,"DirVer"]
["Action","Name","Panther ID","Date/Time","S01"]
["Start S01","Dallan Delgado","002-46-2565","2021-03-12T18:42:19.450","Tom "]
["Start S01","Dallan Delgado","002-46-2565","2021-03-10T13:45:02.730","C:\\Users\\Tom\\AppData\\Local\\Temp"]
["Starter Sheet","None",0,"2020-01-01","Welcome to Microsoft Excel version 16.0 build 13628 running on Windows (32-bit) NT 10.00!"]
[null,null,null,null,"S01"]
[null,null,null,null,"Dallan Delgado"]
[]
[null,null,null,null,"Welcome to Microsoft Excel version 16.46 build 212 running on Macintosh (Intel) Version 11.0.1 (Build 20B29)!"]

{"sheet":"Financial information ","index":2,"n_rows":64,"n_cols":26,"rows_kept":64,"cut":false,"hidden":false,"merged":[[36,1,36,2]]}
["Donut Information ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]
["Based on the below data, create the profit model for Donuts to Go.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado"]
["Assume that each customer will buy one donut and one cup of coffee"]
[" "]
[null,null,null,null,null,"Enter totals "]
[null,"Time period",null,null,"Fixed Costs",{"$f":"C11+C13+C14+C17+C18+C19+C20+C21+C22+C23+C25+C26","v":5550}]
["Revenue: Cup of Coffee",null,4,null,"Varible Costs"]
["Revenue: Donut"," ",3.5,null,"Coffee",{"$f":"C15+C16","v":0.35}]
["Donut ingredients per donunt)","per donut",0.5,null,"Donut",{"$f":"C9","v":0.5}]
["paper products: napkins, plates etc"]
["Insurance","month",200]
[" "]
["Maintenance & Repairs to equipment","month",0]
["Marketing & Promotion: Advertising","month",50]
["Coffee ","per cup",0.25]
["Coffee cups ","per cup",0.1]
["Payroll:  Wages (Owner/ Manager)","month",2500]
["Payroll:  Wages (per Employees)","month",1000,null,null,null,null,null," "]
["Donut and Coffee equipment rent ","month",500]
["Professional Fees: Accounting","month",50]
["Professional Fees: Legal","month",25]
["Powdered and Liquid Beverages",null,0]
["Rent","month",1000]
["Previous research expense for Donuts advancements",null,1500]
["Supplies: Office","month",25]
["Utilities","month",200," "]
[" ",null," "]
[]
[]
["Additional Data"]
["Monthly Production","Lost Sales","Day old revenue","High demand, % above Average","Low Demand, % below average"]
[4000,3,1.25,0.22,0.26]
["Franchise "]
["Monthly Fixed Expense increase",7000]
["Monthly Production Increase",0.32]
["Monthly demand increase",0.24]
["States of Natures ","probabilities "]
["High demand",0.2]
["Average demand",0.55000000000000004]
["Low demand",0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total "]

{"sheet":"SI and regression Pt 1","index":3,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["Month","Demand","Yearly average","Seasonal Index","Average SI","Deseasonalized","Time period",null,null,"Regression Output"]
["2018-01-01",2475,null,{"$f":"B2/$C$13","v":0.80922020598332511},{"$f":"(D2+D14+D26)/3","v":0.72321735436293821},{"$f":"B2/E2","v":3422.2077015562741},1,null,"CLICK CELL J2 as output cell for regression","SUMMARY OUTPUT"]
["2018-02-01",2665.5,null,{"$f":"B3/$C$13","v":0.8715056400196175},{"$f":"(D3+D15+D27)/3","v":0.86924431576310479},{"$f":"B3/E3","v":3066.45663556623},2]
["2018-03-01",3597.5,null,1.1762301781919242,0.94544479054229813,3805.0873366561236,3,null,null,"Regression Statistics"]
["2018-04-01",3104,null,1.0148765734837339,0.9824600021075599,3159.4161526589796,4,null,null,"Multiple R",0.594717571902737]
["2018-05-01",2410,null,0.78796795814941967,0.97783484912260932,2464.6288707775575,5,null,null,"R Square",0.35368899032988721]
["2018-06-01",3592,null,1.1744319110675168,1.1135253751879617,3225.7908800629484,6,null,null,"Adjusted R Square",0.3346798429866486]
["2018-07-01",2740,null,0.89586398561386305,0.85653488363320396,3198.9356795109315,7,null,null,"Standard Error",274.43961293901913]
["2018-08-01",2683.5,null,0.87739087788131442,0.91873818666625706,2920.8538830168536,8,null,null,"Observations",36]
["2018-09-01",2697.5,null,0.88196828510707859,0.87974833353589554,3066.2178002181308,9]
["2018-10-01",3090,null,1.0102991662579697,1.0940468773930256,2824.3762345568562,10,null,null,"ANOVA"]
["2018-11-01",3342.5,"Put yearly average in below cell ",1.0928559751512179,1.2300957035048155,2717.2682503292031,11,null,null,null,"df","SS","MS","F","Significance F"]
["2018-12-01",4304.5,{"$f":"AVERAGE(B2:B13)","v":3058.5},1.4073892430930195,1.4091093281803309,3054.7665208906569,12,null,null,"Regression",1,1401368.9819619735,1401368.9819619735,18.606252239698239,1.3071566905954398E-4]
["2019-01-01",2135,null,{"$f":"B14/$C$25","v":0.64003597391890876},{"$f":"(D2+D14+D26)/3","v":0.72321735436293821},2952.0862395243007,13,null,null,"Residual",34,2560781.4391040336,75317.101150118629]
["2019-02-01",2971,null,{"$f":"B15/$C$25","v":0.89065427565015365},{"$f":"(D3+D15+D27)/3","v":0.86924431576310479},3417.911335309424,14,null,null,"Total",35,3962150.4210660071]
["2019-03-01",2811,null,0.84268905043843212,0.94544479054229813,2973.2037535345003,15]
["2019-04-01",3144,null,0.94251667541032746,0.9824600021075599,3200.130278337575,16,null,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
["2019-05-01",3464.5,null,1.0385970171625571,0.97783484912260932,3543.0318351903934,17,null,null,"Intercept",2975.0745258649222,93.419589257699258,31.846367014718261,6.7207571133060488E-27,2785.2230785332463,3164.9259731965981,2785.2230785332463,3164.9259731965981]
["2019-06-01",3609.5,null,1.0820655025106798,1.1135253751879617,3241.5067320677099,18,null,null,"Time period",18.992438934211382,4.4030263708819373,4.3134965213499612,1.3071566905954474E-4,10.044412767605442,27.94046510081732,10.044412767605442,27.94046510081732]
["2019-07-01",2770,null,0.83039796147792855,0.85653488363320396,3233.9605227172556,19]
["2019-08-01",3077,null,0.9224312373529191,0.91873818666625706,3349.1587099097669,20]
["2019-09-01",3064,null,0.91853406280446681,0.87974833353589554,3482.8142131115301,21]
["2019-10-01",3744,null,1.1223862699542833,1.0940468773930256,3422.1568356572388,22]
["2019-11-01",4253.5,"Put yearly average in below cell ",1.2751255339878589,1.2300957035048155,3457.861032991852,23]
["2019-12-01",4985.5,{"$f":"AVERAGE(B14:B25)","v":3335.75},1.4945664393314846,1.4091093281803309,3538.0505261703729,24]
["2020-01-01",2584,null,{"$f":"B26/$C$37","v":0.72039588318658088},{"$f":"(D2+D14+D26)/3","v":0.72321735436293821},3572.9231114429945,25]
["2020-02-01",3033,null,{"$f":"B27/$C$37","v":0.84557303161954334},{"$f":"(D3+D15+D27)/3","v":0.86924431576310479},3489.2376573522324,26]
["2020-03-01",2932,null,0.81741514299653839,0.94544479054229813,3101.1858432455192,27]
["2020-04-01",3551,null,0.98998675742861797,0.9824600021075599,3614.3965071172797,28]
["2020-05-01",3970.5,null,1.1069395720558513,0.97783484912260932,4060.5016312955572,29]
["2020-06-01",3888.5,null,1.0840787119856887,1.1135253751879617,3492.0623154578998,30]
["2020-07-01",3025,null,0.84334270380782017,0.85653488363320396,3531.6716899710104,31]
["2020-08-01",3430.5,null,0.95639244476453777,0.91873818666625706,3733.9255620232225,32]
["2020-09-01",3008.5,null,0.83874265269614112,0.87974833353589554,3419.7279896037985,33]
["2020-10-01",4123,null,1.149455195966824,1.0940468773930256,3768.5770922582255,34]
["2020-11-01",4743,"Put yearly average in below cell ",1.3223056013753689,1.2300957035048155,3855.7975501305641,35,null,"Use the average seasonal Index  in the column for year 2018"]
["2020-12-01",4754,{"$f":"AVERAGE(B26:B37)","v":3586.9166666666665},1.3253723021164883,1.4091093281803309,{"$f":"B37/E37","v":3373.7623511009833},36,"Deseasonalized forecast","Seasonalized forecast"]
[null,null,null,null,null,null,37,{"$f":"$K$18+($K$19*G38)","v":3677.794766430743},{"$f":"H38*E2","v":2659.8450008679024},"When you move your forecast to the profit models, you must use an equation, not just copy the values"]
[null,null,null,null,null,null,38,{"$f":"$K$18+($K$19*G39)","v":3696.7872053649548},{"$f":"H39*E3","v":3213.4112648492605}]
[null,null,null,null,null,null,39,3715.7796442991662,3513.06450750576]
[null,null,null,null,null,null,40,3734.7720832333775,3669.2641887647201]
[null,null,null,null,null,null,41,3753.7645221675889,3670.5617651755479]
[null,null,null,null,null,null,42,3772.7569611018002,4201.0606106038767]
[null,null,null,null,null,null,43,3791.7494000360116,3247.7656311261162]
[null,null,null,null,null,null,44,3810.7418389702229,3501.0740469887405]
[null,null,null,null,null,null,45,3829.7342779044343,3369.2023488717223]
[null,null,null,null,null,null,46,3848.7267168386456,4210.6874464964321]
[null,null,null,null,null,null,47,3867.719155772857,4757.6647158794631]
[null,null,null,null,null,null,48,3886.7115947070688,{"$f":"H49*E13","v":5476.80156404838}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Current operations Pt2 & Pt3 ","index":4,"n_rows":201,"n_cols":26,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["CURRENT OPERATIONS",null,null,null,"Monthly Production","Lost Sales","Day old revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test"]
["Part 2",null,null,null,{"$f":"'Financial information '!A32","v":4000},{"$f":"'Financial information '!B32","v":3},{"$f":"'Financial information '!C32","v":1.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer 2020 "]
["AVERAGE DEMAND"]
["Month ","Jan","Feb","March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"'SI and regression Pt 1'!I38","v":2659.8450008679024},{"$f":"'SI and regression Pt 1'!I39","v":3213.4112648492605},{"$f":"'SI and regression Pt 1'!I40","v":3513.06450750576},{"$f":"'SI and regression Pt 1'!I41","v":3669.2641887647201},{"$f":"'SI and regression Pt 1'!I42","v":3670.5617651755479},{"$f":"'SI and regression Pt 1'!I43","v":4201.0606106038767},{"$f":"'SI and regression Pt 1'!I44","v":3247.7656311261162},{"$f":"'SI and regression Pt 1'!I45","v":3501.0740469887405},{"$f":"'SI and regression Pt 1'!I46","v":3369.2023488717223},{"$f":"'SI and regression Pt 1'!I47","v":4210.6874464964321},{"$f":"'SI and regression Pt 1'!I48","v":4757.6647158794631},{"$f":"'SI and regression Pt 1'!I49","v":5476.80156404838},{"$f":"AVERAGE(B5:M5)","v":3790.866924264827}]
["satisfied demand",{"$f":"IF(B5<$E$2,B5,$E$2)","v":2659.8450008679024},{"$f":"IF(C5<$E$2,C5,$E$2)","v":3213.4112648492605},{"$f":"IF(D5<$E$2,D5,$E$2)","v":3513.06450750576},3669.2641887647201,3670.5617651755479,4000,3247.7656311261162,3501.0740469887405,3369.2023488717223,4000,4000,4000]
["Extra donuts(over) ",{"$f":"IF($E$2>B5,$E$2-B5,0)","v":1340.1549991320976},{"$f":"IF($E$2>C5,$E$2-C5,0)","v":786.58873515073947},{"$f":"IF($E$2>D5,$E$2-D5,0)","v":486.93549249423995},330.73581123527993,329.43823482445214,0,752.2343688738838,498.92595301125948,630.79765112827772,0,0,0]
["Unsatisfied customers (short)",{"$f":"IF($E$2<B5,B5-$E$2,0)","v":0},{"$f":"IF($E$2<C5,C5-$E$2,0)","v":0},{"$f":"IF($E$2<D5,D5-$E$2,0)","v":0},0,0,201.06061060387674,0,0,0,210.68744649643213,757.66471587946307,1476.80156404838]
["Revenue"]
["coffee ",{"$f":"B6*'Financial information '!$C$7","v":10639.38000347161},{"$f":"C6*'Financial information '!$C$7","v":12853.645059397042},{"$f":"D6*'Financial information '!$C$7","v":14052.25803002304},{"$f":"E6*'Financial information '!$C$7","v":14677.05675505888},{"$f":"F6*'Financial information '!$C$7","v":14682.247060702191},{"$f":"G6*'Financial information '!$C$7","v":16000},{"$f":"H6*'Financial information '!$C$7","v":12991.062524504465},{"$f":"I6*'Financial information '!$C$7","v":14004.296187954962},{"$f":"J6*'Financial information '!$C$7","v":13476.809395486889},{"$f":"K6*'Financial information '!$C$7","v":16000},{"$f":"L6*'Financial information '!$C$7","v":16000},{"$f":"M6*'Financial information '!$C$7","v":16000}]
["donut",{"$f":"B6*'Financial information '!$C$8","v":9309.4575030376582},{"$f":"C6*'Financial information '!$C$8","v":11246.939426972413},{"$f":"D6*'Financial information '!$C$8","v":12295.725776270159},{"$f":"E6*'Financial information '!$C$8","v":12842.424660676521},{"$f":"F6*'Financial information '!$C$8","v":12846.966178114417},{"$f":"G6*'Financial information '!$C$8","v":14000},{"$f":"H6*'Financial information '!$C$8","v":11367.179708941407},{"$f":"I6*'Financial information '!$C$8","v":12253.759164460593},{"$f":"J6*'Financial information '!$C$8","v":11792.208221051027},{"$f":"K6*'Financial information '!$C$8","v":14000},{"$f":"L6*'Financial information '!$C$8","v":14000},{"$f":"M6*'Financial information '!$C$8","v":14000}]
["Revenue from day old sales ",{"$f":"SUM(B10:B11)","v":19948.83750650927},{"$f":"SUM(C10:C11)","v":24100.584486369455},26347.983806293199,27519.481415735401,27529.213238816606,30000,24358.242233445872,26258.055352415555,25269.017616537916,30000,30000,30000]
["Total Revenue"]
["Expenses"]
["Fixed Expenses",{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550}]
["Total Fixed Expense",{"$f":"B15","v":5550},{"$f":"C15","v":5550},5550,5550,5550,5550,5550,5550,5550,5550,5550,5550]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400}]
["Donut Variable expense",{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000}]
["Total Variable Expenses",{"$f":"SUM(B19:B20)","v":3400},{"$f":"SUM(C19:C20)","v":3400},3400,3400,3400,3400,3400,3400,3400,3400,3400,3400]
["Expenses: due to lost sales"]
["Total  Expenses",{"$f":"B21+B16","v":8950},{"$f":"C21+C16","v":8950},8950,8950,8950,8950,8950,8950,8950,8950,8950,8950]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B12-B23+B7*G2-B8*$F$2","v":12674.031255424392},{"$f":"C12-C23+C7*H2-C8*$F$2","v":15150.584486369455},{"$f":"D12-D23+D7*I2-D8*$F$2","v":17397.983806293199},18569.481415735401,18579.213238816606,20446.818168188369,15408.242233445872,17308.055352415555,16319.017616537916,20417.937660510703,18777.00585236161,16619.595307854859,{"$f":"SUM(B25:M25)","v":207667.96639395395}]
[]
["Part 3","You should be able to copy from average to high and low and then just make some modifications"]
["HIGH DEMAND"]
["Month ",{"$f":"B4","v":"Jan"},{"$f":"C4","v":"Feb"},"March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"B5*(1+'Financial information '!$D$32)","v":3245.0109010588408},{"$f":"C5*(1+'Financial information '!$D$32)","v":3920.3617431160978},{"$f":"D5*(1+'Financial information '!$D$32)","v":4285.9386991570273},{"$f":"E5*(1+'Financial information '!$D$32)","v":4476.5023102929581},{"$f":"F5*(1+'Financial information '!$D$32)","v":4478.0853535141687},{"$f":"G5*(1+'Financial information '!$D$32)","v":5125.2939449367295},{"$f":"H5*(1+'Financial information '!$D$32)","v":3962.2740699738615},{"$f":"I5*(1+'Financial information '!$D$32)","v":4271.3103373262629},{"$f":"J5*(1+'Financial information '!$D$32)","v":4110.4268656235008},{"$f":"K5*(1+'Financial information '!$D$32)","v":5137.0386847256468},{"$f":"L5*(1+'Financial information '!$D$32)","v":5804.3509533729448},{"$f":"M5*(1+'Financial information '!$D$32)","v":6681.6979081390236}]
["satisfied demand",{"$f":"IF(B30<$E$2,B30,$E$2)","v":3245.0109010588408},{"$f":"IF(C30<$E$2,C30,$E$2)","v":3920.3617431160978},{"$f":"IF(D30<$E$2,D30,$E$2)","v":4000},4000,4000,4000,3962.2740699738615,4000,4000,4000,4000,4000]
["Extra donuts(over) ",{"$f":"IF($E$2>B30,$E$2-B30,0)","v":754.98909894115923},{"$f":"IF($E$2>C30,$E$2-C30,0)","v":79.638256883902159},{"$f":"IF($E$2>D30,$E$2-D30,0)","v":0},0,0,0,37.725930026138485,0,0,0,0,0]
["Unsatisfied customers (short)",{"$f":"IF($E$2<B30,B30-$E$2,0)","v":0},{"$f":"C8","v":0},0,0,0,201.06061060387674,0,0,0,210.68744649643213,757.66471587946307,1476.80156404838]
["Revenue"]
["coffee ",{"$f":"B31*'Financial information '!$C$7","v":12980.043604235363},{"$f":"C31*'Financial information '!$C$7","v":15681.446972464391},{"$f":"D31*'Financial information '!$C$7","v":16000},{"$f":"E31*'Financial information '!$C$7","v":16000},{"$f":"F31*'Financial information '!$C$7","v":16000},{"$f":"G31*'Financial information '!$C$7","v":16000},{"$f":"H31*'Financial information '!$C$7","v":15849.096279895446},{"$f":"I31*'Financial information '!$C$7","v":16000},{"$f":"J31*'Financial information '!$C$7","v":16000},{"$f":"K31*'Financial information '!$C$7","v":16000},{"$f":"L31*'Financial information '!$C$7","v":16000},{"$f":"M31*'Financial information '!$C$7","v":16000}]
["donut",{"$f":"B31*'Financial information '!$C$8","v":11357.538153705942},{"$f":"C31*'Financial information '!$C$8","v":13721.266100906343},{"$f":"D31*'Financial information '!$C$8","v":14000},{"$f":"E31*'Financial information '!$C$8","v":14000},{"$f":"F31*'Financial information '!$C$8","v":14000},{"$f":"G31*'Financial information '!$C$8","v":14000},{"$f":"H31*'Financial information '!$C$8","v":13867.959244908516},{"$f":"I31*'Financial information '!$C$8","v":14000},{"$f":"J31*'Financial information '!$C$8","v":14000},{"$f":"K31*'Financial information '!$C$8","v":14000},{"$f":"L31*'Financial information '!$C$8","v":14000},{"$f":"M31*'Financial information '!$C$8","v":14000}]
["Revenue from day old sales ",{"$f":"SUM(B35:B36)","v":24337.581757941305},{"$f":"SUM(C35:C36)","v":29402.713073370734},{"$f":"SUM(D35:D36)","v":30000},30000,30000,30000,29717.05552480396,30000,30000,30000,30000,30000]
["Total Revenue"]
["Expenses"]
["Fixed Expenses",{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550}]
["Total Fixed Expense",{"$f":"B40","v":5550},{"$f":"C40","v":5550},{"$f":"D40","v":5550},5550,5550,5550,5550,5550,5550,5550,5550,5550]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400}]
["Donut Variable expense",{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000}]
["Total Variable Expenses",{"$f":"SUM(B44:B45)","v":3400},{"$f":"SUM(C44:C45)","v":3400},{"$f":"SUM(D44:D45)","v":3400},3400,3400,3400,3400,3400,3400,3400,3400,3400]
["Expenses: due to lost sales"]
["Total  Expenses",{"$f":"B46+B41","v":8950},{"$f":"C46+C41","v":8950},{"$f":"D46+D41","v":8950},8950,8950,8950,8950,8950,8950,8950,8950,8950]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B37-B48+B32*G27-B33*$F$2","v":15387.581757941305},{"$f":"C37-C48+C32*H27-C33*$F$2","v":20452.713073370734},{"$f":"D37-D48+D32*I27-D33*$F$2","v":21050},21050,21050,20446.818168188369,20767.05552480396,21050,21050,20417.937660510703,18777.00585236161,16619.595307854859,{"$f":"SUM(B50:M50)","v":238118.70734503155}]
[]
["Part 3"]
["LOW DEMAND"]
["Month ",{"$f":"B29","v":"Jan"},{"$f":"C29","v":"Feb"},"March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"B5*(1-'Financial information '!$E$32)","v":1968.2853006422476},{"$f":"C5*(1-'Financial information '!$E$32)","v":2377.9243359884526},{"$f":"D5*(1-'Financial information '!$E$32)","v":2599.6677355542624},{"$f":"E5*(1-'Financial information '!$E$32)","v":2715.255499685893},{"$f":"F5*(1-'Financial information '!$E$32)","v":2716.2157062299052},{"$f":"G5*(1-'Financial information '!$E$32)","v":3108.7848518468686},{"$f":"H5*(1-'Financial information '!$E$32)","v":2403.3465670333258},{"$f":"I5*(1-'Financial information '!$E$32)","v":2590.794794771668},{"$f":"J5*(1-'Financial information '!$E$32)","v":2493.2097381650747},{"$f":"K5*(1-'Financial information '!$E$32)","v":3115.9087104073596},{"$f":"L5*(1-'Financial information '!$E$32)","v":3520.6718897508026},{"$f":"M5*(1-'Financial information '!$E$32)","v":4052.8331573958012}]
["satisfied demand",{"$f":"IF(B55<$E$2,B55,$E$2)","v":1968.2853006422476},{"$f":"IF(C55<$E$2,C55,$E$2)","v":2377.9243359884526},{"$f":"IF(D55<$E$2,D55,$E$2)","v":2599.6677355542624},{"$f":"IF(E55<$E$2,E55,$E$2)","v":2715.255499685893},{"$f":"IF(F55<$E$2,F55,$E$2)","v":2716.2157062299052},{"$f":"IF(G55<$E$2,G55,$E$2)","v":3108.7848518468686},{"$f":"IF(H55<$E$2,H55,$E$2)","v":2403.3465670333258},{"$f":"IF(I55<$E$2,I55,$E$2)","v":2590.794794771668},{"$f":"IF(J55<$E$2,J55,$E$2)","v":2493.2097381650747},{"$f":"IF(K55<$E$2,K55,$E$2)","v":3115.9087104073596},{"$f":"IF(L55<$E$2,L55,$E$2)","v":3520.6718897508026},{"$f":"IF(M55<$E$2,M55,$E$2)","v":4000}]
["Extra donuts(over) ",{"$f":"IF($E$2>B55,$E$2-B55,0)","v":2031.7146993577524},{"$f":"IF($E$2>C55,$E$2-C55,0)","v":1622.0756640115474},{"$f":"IF($E$2>D55,$E$2-D55,0)","v":1400.3322644457376},1284.744500314107,1283.7842937700948,891.21514815313139,1596.6534329666742,1409.205205228332,1506.7902618349253,884.09128959264035,479.32811024919738,0]
["Unsatisfied customers (short)",{"$f":"IF($E$2<B55,B55-$E$2,0)","v":0},{"$f":"C33","v":0},0,0,0,201.06061060387674,0,0,0,210.68744649643213,757.66471587946307,1476.80156404838]
["Revenue"]
["coffee ",{"$f":"B56*'Financial information '!$C$7","v":7873.1412025689906},{"$f":"C56*'Financial information '!$C$7","v":9511.6973439538106},{"$f":"D56*'Financial information '!$C$7","v":10398.67094221705},{"$f":"E56*'Financial information '!$C$7","v":10861.021998743572},{"$f":"F56*'Financial information '!$C$7","v":10864.862824919621},{"$f":"G56*'Financial information '!$C$7","v":12435.139407387474},{"$f":"H56*'Financial information '!$C$7","v":9613.386268133303},{"$f":"I56*'Financial information '!$C$7","v":10363.179179086672},{"$f":"J56*'Financial information '!$C$7","v":9972.8389526602987},{"$f":"K56*'Financial information '!$C$7","v":12463.634841629439},{"$f":"L56*'Financial information '!$C$7","v":14082.68755900321},{"$f":"M56*'Financial information '!$C$7","v":16000}]
["donut",{"$f":"B56*'Financial information '!$C$8","v":6888.9985522478664},{"$f":"C56*'Financial information '!$C$8","v":8322.735175959584},{"$f":"D56*'Financial information '!$C$8","v":9098.8370744399181},{"$f":"E56*'Financial information '!$C$8","v":9503.3942489006258},{"$f":"F56*'Financial information '!$C$8","v":9506.7549718046685},{"$f":"G56*'Financial information '!$C$8","v":10880.746981464041},{"$f":"H56*'Financial information '!$C$8","v":8411.7129846166408},{"$f":"I56*'Financial information '!$C$8","v":9067.7817817008381},{"$f":"J56*'Financial information '!$C$8","v":8726.2340835777613},{"$f":"K56*'Financial information '!$C$8","v":10905.680486425759},{"$f":"L56*'Financial information '!$C$8","v":12322.351614127809},{"$f":"M56*'Financial information '!$C$8","v":14000}]
["Revenue from day old sales ",{"$f":"SUM(B60:B61)","v":14762.139754816857},{"$f":"SUM(C60:C61)","v":17834.432519913396},{"$f":"SUM(D60:D61)","v":19497.508016656968},{"$f":"SUM(E60:E61)","v":20364.4162476442},{"$f":"SUM(F60:F61)","v":20371.617796724291},{"$f":"SUM(G60:G61)","v":23315.886388851515},{"$f":"SUM(H60:H61)","v":18025.099252749944},{"$f":"SUM(I60:I61)","v":19430.96096078751},{"$f":"SUM(J60:J61)","v":18699.07303623806},{"$f":"SUM(K60:K61)","v":23369.3153280552},{"$f":"SUM(L60:L61)","v":26405.039173131019},{"$f":"SUM(M60:M61)","v":30000}]
["Total Revenue"]
["Expenses"]
["Fixed Expenses",{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550}]
["Total Fixed Expense",{"$f":"B65","v":5550},{"$f":"C65","v":5550},{"$f":"D65","v":5550},{"$f":"E65","v":5550},{"$f":"F65","v":5550},{"$f":"G65","v":5550},{"$f":"H65","v":5550},{"$f":"I65","v":5550},{"$f":"J65","v":5550},{"$f":"K65","v":5550},{"$f":"L65","v":5550},{"$f":"M65","v":5550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400},{"$f":"'Financial information '!$F$8*$E$2","v":1400}]
["Donut Variable expense",{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000},{"$f":"'Financial information '!$F$9*$E$2","v":2000}]
["Total Variable Expenses",{"$f":"SUM(B69:B70)","v":3400},{"$f":"SUM(C69:C70)","v":3400},{"$f":"SUM(D69:D70)","v":3400},{"$f":"SUM(E69:E70)","v":3400},{"$f":"SUM(F69:F70)","v":3400},{"$f":"SUM(G69:G70)","v":3400},{"$f":"SUM(H69:H70)","v":3400},{"$f":"SUM(I69:I70)","v":3400},{"$f":"SUM(J69:J70)","v":3400},{"$f":"SUM(K69:K70)","v":3400},{"$f":"SUM(L69:L70)","v":3400},{"$f":"SUM(M69:M70)","v":3400}]
["Expenses: due to lost sales"]
["Total  Expenses",{"$f":"B71+B66","v":8950},{"$f":"C71+C66","v":8950},{"$f":"D71+D66","v":8950},8950,8950,8950,8950,8950,8950,8950,8950,8950]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B62-B73+B57*G52-B58*$F$2","v":5812.139754816857},{"$f":"C62-C73+C57*H52-C58*$F$2","v":8884.4325199133964},{"$f":"D62-D73+D57*I52-D58*$F$2","v":10547.508016656968},{"$f":"E62-E73+E57*J52-E58*$F$2","v":11414.4162476442},{"$f":"F62-F73+F57*K52-F58*$F$2","v":11421.617796724291},{"$f":"G62-G73+G57*L52-G58*$F$2","v":13762.704557039884},{"$f":"H62-H73+H57*M52-H58*$F$2","v":9075.0992527499438},{"$f":"I62-I73+I57*N52-I58*$F$2","v":10480.96096078751},{"$f":"J62-J73+J57*O52-J58*$F$2","v":9749.07303623806},{"$f":"K62-K73+K57*P52-K58*$F$2","v":13787.252988565902},{"$f":"L62-L73+L57*Q52-L58*$F$2","v":15182.045025492629},{"$f":"M62-M73+M57*R52-M58*$F$2","v":16619.595307854859},{"$f":"SUM(B75:M75)","v":136736.84546448448}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Franchise operations Pt2 & Pt3","index":5,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["FRANCHISE",null,null,null,"Monthly Production","Lost Sales","Day old revenue"]
["Part 2",null,null,null,{"$f":"'Financial information '!A32*(1+'Financial information '!$B$35)","v":5280},{"$f":"'Financial information '!B32","v":3},{"$f":"'Financial information '!C32","v":1.25}]
["AVERAGE DEMAND"]
["Month ",{"$f":"'Current operations Pt2 & Pt3 '!B29","v":"Jan"},{"$f":"'Current operations Pt2 & Pt3 '!C29","v":"Feb"},{"$f":"'Current operations Pt2 & Pt3 '!D29","v":"March"},{"$f":"'Current operations Pt2 & Pt3 '!E29","v":"April"},{"$f":"'Current operations Pt2 & Pt3 '!F29","v":"May"},{"$f":"'Current operations Pt2 & Pt3 '!G29","v":"June"},{"$f":"'Current operations Pt2 & Pt3 '!H29","v":"July"},{"$f":"'Current operations Pt2 & Pt3 '!I29","v":"August"},{"$f":"'Current operations Pt2 & Pt3 '!J29","v":"September"},{"$f":"'Current operations Pt2 & Pt3 '!K29","v":"October"},{"$f":"'Current operations Pt2 & Pt3 '!L29","v":"November"},{"$f":"'Current operations Pt2 & Pt3 '!M29","v":"December"}]
["Demand",{"$f":"'SI and regression Pt 1'!I38*(1+'Financial information '!$B$36)","v":3298.2078010761988},{"$f":"'SI and regression Pt 1'!I39*(1+'Financial information '!$B$36)","v":3984.6299684130831},{"$f":"'SI and regression Pt 1'!I40*(1+'Financial information '!$B$36)","v":4356.1999893071425},{"$f":"'SI and regression Pt 1'!I41*(1+'Financial information '!$B$36)","v":4549.8875940682528},{"$f":"'SI and regression Pt 1'!I42*(1+'Financial information '!$B$36)","v":4551.4965888176794},{"$f":"'SI and regression Pt 1'!I43*(1+'Financial information '!$B$36)","v":5209.315157148807},{"$f":"'SI and regression Pt 1'!I44*(1+'Financial information '!$B$36)","v":4027.2293825963839},{"$f":"'SI and regression Pt 1'!I45*(1+'Financial information '!$B$36)","v":4341.3318182660378},{"$f":"'SI and regression Pt 1'!I46*(1+'Financial information '!$B$36)","v":4177.8109126009358},{"$f":"'SI and regression Pt 1'!I47*(1+'Financial information '!$B$36)","v":5221.2524336555762},{"$f":"'SI and regression Pt 1'!I48*(1+'Financial information '!$B$36)","v":5899.5042476905346},{"$f":"'SI and regression Pt 1'!I49*(1+'Financial information '!$B$36)","v":6791.2339394199907}]
["satisfied demand",{"$f":"IF(B5<$E$2,B5,$E$2)","v":3298.2078010761988},{"$f":"IF(C5<$E$2,C5,$E$2)","v":3984.6299684130831},{"$f":"IF(D5<$E$2,D5,$E$2)","v":4356.1999893071425},4549.8875940682528,4551.4965888176794,5209.315157148807,4027.2293825963839,4341.3318182660378,4177.8109126009358,5221.2524336555762,5280,5280]
["Extra donuts(over) ",{"$f":"IF($E$2>B5,$E$2-B5,0)","v":1981.7921989238012},{"$f":"IF($E$2>C5,$E$2-C5,0)","v":1295.3700315869169},{"$f":"IF($E$2>D5,$E$2-D5,0)","v":923.80001069285754},730.11240593174716,728.50341118232063,70.684842851193025,1252.7706174036161,938.66818173396223,1102.1890873990642,58.747566344423831,0,0]
["Unsatisfied customers (short)",{"$f":"IF($E$2<B5,B5-$E$2,0)","v":0},{"$f":"IF($E$2<C5,C5-$E$2,0)","v":0},{"$f":"IF($E$2<D5,D5-$E$2,0)","v":0},0,0,0,0,0,0,0,619.50424769053461,1511.2339394199907]
["Revenue"]
["coffee ",{"$f":"B6*'Financial information '!$C$7","v":13192.831204304795},{"$f":"C6*'Financial information '!$C$7","v":15938.519873652333},{"$f":"D6*'Financial information '!$C$7","v":17424.79995722857},{"$f":"E6*'Financial information '!$C$7","v":18199.550376273011},{"$f":"F6*'Financial information '!$C$7","v":18205.986355270717},{"$f":"G6*'Financial information '!$C$7","v":20837.260628595228},{"$f":"H6*'Financial information '!$C$7","v":16108.917530385535},{"$f":"I6*'Financial information '!$C$7","v":17365.327273064151},{"$f":"J6*'Financial information '!$C$7","v":16711.243650403743},{"$f":"K6*'Financial information '!$C$7","v":20885.009734622305},{"$f":"L6*'Financial information '!$C$7","v":21120},{"$f":"M6*'Financial information '!$C$7","v":21120}]
["donut",{"$f":"B6*'Financial information '!$C$8","v":11543.727303766696},{"$f":"C6*'Financial information '!$C$8","v":13946.204889445791},{"$f":"D6*'Financial information '!$C$8","v":15246.699962575},{"$f":"E6*'Financial information '!$C$8","v":15924.606579238885},{"$f":"F6*'Financial information '!$C$8","v":15930.238060861877},{"$f":"G6*'Financial information '!$C$8","v":18232.603050020825},{"$f":"H6*'Financial information '!$C$8","v":14095.302839087344},{"$f":"I6*'Financial information '!$C$8","v":15194.661363931133},{"$f":"J6*'Financial information '!$C$8","v":14622.338194103275},{"$f":"K6*'Financial information '!$C$8","v":18274.383517794515},{"$f":"L6*'Financial information '!$C$8","v":18480},{"$f":"M6*'Financial information '!$C$8","v":18480}]
["Revenue from day old sales ",{"$f":"SUM(B10:B11)","v":24736.558508071492},{"$f":"SUM(C10:C11)","v":29884.724763098122},32671.499919803569,34124.156955511899,34136.224416132594,39069.86367861605,30204.220369472881,32559.988636995284,31333.581844507018,39159.393252416819,39600,39600]
["Total Revenue"]
["Expenses"]
["Fixed Expenses",{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550}]
["Total Fixed Expense",{"$f":"B15+'Financial information '!$B$34","v":12550},{"$f":"C15+'Financial information '!$B$34","v":12550},{"$f":"D15+'Financial information '!$B$34","v":12550},{"$f":"E15+'Financial information '!$B$34","v":12550},{"$f":"F15+'Financial information '!$B$34","v":12550},{"$f":"G15+'Financial information '!$B$34","v":12550},{"$f":"H15+'Financial information '!$B$34","v":12550},{"$f":"I15+'Financial information '!$B$34","v":12550},{"$f":"J15+'Financial information '!$B$34","v":12550},{"$f":"K15+'Financial information '!$B$34","v":12550},{"$f":"L15+'Financial information '!$B$34","v":12550},{"$f":"M15+'Financial information '!$B$34","v":12550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998}]
["Donut Variable expense",{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640}]
["Total Variable Expenses",{"$f":"SUM(B19:B20)","v":4488},{"$f":"SUM(C19:C20)","v":4488},4488,4488,4488,4488,4488,4488,4488,4488,4488,4488]
["Expenses: due to lost sales"]
["Total  Expenses",{"$f":"B21+B16","v":17038},{"$f":"C21+C16","v":17038},17038,17038,17038,17038,17038,17038,17038,17038,17038,17038]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B12-B23+B7*G2-B8*$F$2","v":10175.798756726243},{"$f":"C12-C23+C7*H2-C8*$F$2","v":12846.724763098122},{"$f":"D12-D23+D7*I2-D8*$F$2","v":15633.499919803569},17086.156955511899,17098.224416132594,22031.86367861605,13166.220369472881,15521.988636995284,14295.581844507018,22121.393252416819,20703.487256928398,18028.298181740029,{"$f":"SUM(B25:M25)","v":198709.23803194892}]
[]
["Part 3"]
["HIGH DEMAND"]
["Month ",{"$f":"B4","v":"Jan"},{"$f":"C4","v":"Feb"},"March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"B5*(1+'Financial information '!$D$32)","v":4023.8135173129626},{"$f":"C5*(1+'Financial information '!$D$32)","v":4861.2485614639609},{"$f":"D5*(1+'Financial information '!$D$32)","v":5314.563986954714},{"$f":"E5*(1+'Financial information '!$D$32)","v":5550.8628647632686},{"$f":"F5*(1+'Financial information '!$D$32)","v":5552.8258383575685},{"$f":"G5*(1+'Financial information '!$D$32)","v":6355.3644917215443},{"$f":"H5*(1+'Financial information '!$D$32)","v":4913.219846767588},{"$f":"I5*(1+'Financial information '!$D$32)","v":5296.4248182845658},{"$f":"J5*(1+'Financial information '!$D$32)","v":5096.9293133731417},{"$f":"K5*(1+'Financial information '!$D$32)","v":6369.9279690598032},{"$f":"L5*(1+'Financial information '!$D$32)","v":7197.3951821824521},{"$f":"M5*(1+'Financial information '!$D$32)","v":8285.3054060923878}]
["satisfied demand",{"$f":"IF(B30<$E$2,B30,$E$2)","v":4023.8135173129626},{"$f":"IF(C30<$E$2,C30,$E$2)","v":4861.2485614639609},{"$f":"IF(D30<$E$2,D30,$E$2)","v":5280},5280,5280,5280,4913.219846767588,5280,5096.9293133731417,5280,5280,5280]
["Extra donuts(over) ",{"$f":"IF($E$2>B30,$E$2-B30,0)","v":1256.1864826870374},{"$f":"IF($E$2>C30,$E$2-C30,0)","v":418.75143853603913},{"$f":"IF($E$2>D30,$E$2-D30,0)","v":0},0,0,0,366.78015323241198,0,183.07068662685833,0,0,0]
["Unsatisfied customers (short)",{"$f":"IF($E$2<B30,B30-$E$2,0)","v":0},{"$f":"C8","v":0},0,0,0,0,0,0,0,0,619.50424769053461,1511.2339394199907]
["Revenue"]
["coffee ",{"$f":"B31*'Financial information '!$C$7","v":16095.254069251851},{"$f":"C31*'Financial information '!$C$7","v":19444.994245855843},{"$f":"D31*'Financial information '!$C$7","v":21120},{"$f":"E31*'Financial information '!$C$7","v":21120},{"$f":"F31*'Financial information '!$C$7","v":21120},{"$f":"G31*'Financial information '!$C$7","v":21120},{"$f":"H31*'Financial information '!$C$7","v":19652.879387070352},{"$f":"I31*'Financial information '!$C$7","v":21120},{"$f":"J31*'Financial information '!$C$7","v":20387.717253492567},{"$f":"K31*'Financial information '!$C$7","v":21120},{"$f":"L31*'Financial information '!$C$7","v":21120},{"$f":"M31*'Financial information '!$C$7","v":21120}]
["donut",{"$f":"B31*'Financial information '!$C$8","v":14083.347310595369},{"$f":"C31*'Financial information '!$C$8","v":17014.369965123864},{"$f":"D31*'Financial information '!$C$8","v":18480},{"$f":"E31*'Financial information '!$C$8","v":18480},{"$f":"F31*'Financial information '!$C$8","v":18480},{"$f":"G31*'Financial information '!$C$8","v":18480},{"$f":"H31*'Financial information '!$C$8","v":17196.269463686556},{"$f":"I31*'Financial information '!$C$8","v":18480},{"$f":"J31*'Financial information '!$C$8","v":17839.252596805996},{"$f":"K31*'Financial information '!$C$8","v":18480},{"$f":"L31*'Financial information '!$C$8","v":18480},{"$f":"M31*'Financial information '!$C$8","v":18480}]
["Revenue from day old sales ",{"$f":"SUM(B35:B36)","v":30178.60137984722},{"$f":"SUM(C35:C36)","v":36459.364210979707},{"$f":"SUM(D35:D36)","v":39600},39600,39600,39600,36849.148850756908,39600,38226.969850298563,39600,39600,39600]
["Total Revenue"]
["Expenses"]
["Fixed Expenses",{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550}]
["Total Fixed Expense",{"$f":"B15+'Financial information '!$B$34","v":12550},{"$f":"C15+'Financial information '!$B$34","v":12550},{"$f":"D15+'Financial information '!$B$34","v":12550},{"$f":"E15+'Financial information '!$B$34","v":12550},{"$f":"F15+'Financial information '!$B$34","v":12550},{"$f":"G15+'Financial information '!$B$34","v":12550},{"$f":"H15+'Financial information '!$B$34","v":12550},{"$f":"I15+'Financial information '!$B$34","v":12550},{"$f":"J15+'Financial information '!$B$34","v":12550},{"$f":"K15+'Financial information '!$B$34","v":12550},{"$f":"L15+'Financial information '!$B$34","v":12550},{"$f":"M15+'Financial information '!$B$34","v":12550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998}]
["Donut Variable expense",{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640}]
["Total Variable Expenses",{"$f":"SUM(B44:B45)","v":4488},{"$f":"SUM(C44:C45)","v":4488},{"$f":"SUM(D44:D45)","v":4488},4488,4488,4488,4488,4488,4488,4488,4488,4488]
["Expenses: due to lost sales"]
["Total  Expenses",{"$f":"B46+B41","v":17038},{"$f":"C46+C41","v":17038},{"$f":"D46+D41","v":17038},17038,17038,17038,17038,17038,17038,17038,17038,17038]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B37-B48+B32*G27-B33*$F$2","v":13140.60137984722},{"$f":"C37-C48+C32*H27-C33*$F$2","v":19421.364210979707},{"$f":"D37-D48+D32*I27-D33*$F$2","v":22562},22562,22562,22562,19811.148850756908,22562,21188.969850298563,22562,20703.487256928398,18028.298181740029,{"$f":"SUM(B50:M50)","v":247665.86973055085}]
[]
["Part 3"]
["LOW DEMAND"]
["Month ",{"$f":"B29","v":"Jan"},{"$f":"C29","v":"Feb"},"March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"B5*(1-'Financial information '!$E$32)","v":2440.6737727963873},{"$f":"C5*(1-'Financial information '!$E$32)","v":2948.6261766256816},{"$f":"D5*(1-'Financial information '!$E$32)","v":3223.5879920872853},{"$f":"E5*(1-'Financial information '!$E$32)","v":3366.916819610507},{"$f":"F5*(1-'Financial information '!$E$32)","v":3368.1074757250826},{"$f":"G5*(1-'Financial information '!$E$32)","v":3854.8932162901169},{"$f":"H5*(1-'Financial information '!$E$32)","v":2980.1497431213238},{"$f":"I5*(1-'Financial information '!$E$32)","v":3212.585545516868},{"$f":"J5*(1-'Financial information '!$E$32)","v":3091.5800753246926},{"$f":"K5*(1-'Financial information '!$E$32)","v":3863.7268009051263},{"$f":"L5*(1-'Financial information '!$E$32)","v":4365.6331432909956},{"$f":"M5*(1-'Financial information '!$E$32)","v":5025.5131151707928}]
["satisfied demand",{"$f":"IF(B55<$E$2,B55,$E$2)","v":2440.6737727963873},{"$f":"IF(C55<$E$2,C55,$E$2)","v":2948.6261766256816},{"$f":"IF(D55<$E$2,D55,$E$2)","v":3223.5879920872853},3366.916819610507,3368.1074757250826,3854.8932162901169,2980.1497431213238,3212.585545516868,3091.5800753246926,3863.7268009051263,4365.6331432909956,5025.5131151707928]
["Extra donuts(over) ",{"$f":"IF($E$2>B55,$E$2-B55,0)","v":2839.3262272036127},{"$f":"IF($E$2>C55,$E$2-C55,0)","v":2331.3738233743184},{"$f":"IF($E$2>D55,$E$2-D55,0)","v":2056.4120079127147},1913.083180389493,1911.8925242749174,1425.1067837098831,2299.8502568786762,2067.414454483132,2188.4199246753074,1416.2731990948737,914.36685670900442,254.48688482920716]
["Unsatisfied customers (short)",{"$f":"IF($E$2<B55,B55-$E$2,0)","v":0},{"$f":"C33","v":0},0,0,0,0,0,0,0,0,619.50424769053461,1511.2339394199907]
["Revenue"]
["coffee ",{"$f":"B56*'Financial information '!$C$7","v":9762.6950911855492},{"$f":"C56*'Financial information '!$C$7","v":11794.504706502727},{"$f":"D56*'Financial information '!$C$7","v":12894.351968349141},{"$f":"E56*'Financial information '!$C$7","v":13467.667278442028},{"$f":"F56*'Financial information '!$C$7","v":13472.42990290033},{"$f":"G56*'Financial information '!$C$7","v":15419.572865160468},{"$f":"H56*'Financial information '!$C$7","v":11920.598972485295},{"$f":"I56*'Financial information '!$C$7","v":12850.342182067472},{"$f":"J56*'Financial information '!$C$7","v":12366.320301298771},{"$f":"K56*'Financial information '!$C$7","v":15454.907203620505},{"$f":"L56*'Financial information '!$C$7","v":17462.532573163982},{"$f":"M56*'Financial information '!$C$7","v":20102.052460683171}]
["donut",{"$f":"B56*'Financial information '!$C$8","v":8542.3582047873551},{"$f":"C56*'Financial information '!$C$8","v":10320.191618189885},{"$f":"D56*'Financial information '!$C$8","v":11282.557972305498},{"$f":"E56*'Financial information '!$C$8","v":11784.208868636775},{"$f":"F56*'Financial information '!$C$8","v":11788.376165037789},{"$f":"G56*'Financial information '!$C$8","v":13492.126257015409},{"$f":"H56*'Financial information '!$C$8","v":10430.524100924633},{"$f":"I56*'Financial information '!$C$8","v":11244.049409309038},{"$f":"J56*'Financial information '!$C$8","v":10820.530263636425},{"$f":"K56*'Financial information '!$C$8","v":13523.043803167942},{"$f":"L56*'Financial information '!$C$8","v":15279.716001518485},{"$f":"M56*'Financial information '!$C$8","v":17589.295903097776}]
["Revenue from day old sales ",{"$f":"SUM(B60:B61)","v":18305.053295972903},{"$f":"SUM(C60:C61)","v":22114.69632469261},{"$f":"SUM(D60:D61)","v":24176.909940654637},25251.876147078801,25260.80606793812,28911.699122175876,22351.12307340993,24094.391591376509,23186.850564935194,28977.951006788448,32742.248574682468,37691.348363780948]
["Total Revenue"]
["Expenses"]
["Fixed Expenses",{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550}]
["Total Fixed Expense",{"$f":"B15+'Financial information '!$B$34","v":12550},{"$f":"C15+'Financial information '!$B$34","v":12550},{"$f":"D15+'Financial information '!$B$34","v":12550},{"$f":"E15+'Financial information '!$B$34","v":12550},{"$f":"F15+'Financial information '!$B$34","v":12550},{"$f":"G15+'Financial information '!$B$34","v":12550},{"$f":"H15+'Financial information '!$B$34","v":12550},{"$f":"I15+'Financial information '!$B$34","v":12550},{"$f":"J15+'Financial information '!$B$34","v":12550},{"$f":"K15+'Financial information '!$B$34","v":12550},{"$f":"L15+'Financial information '!$B$34","v":12550},{"$f":"M15+'Financial information '!$B$34","v":12550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998},{"$f":"'Financial information '!$F$8*$E$2","v":1847.9999999999998}]
["Donut Variable expense",{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640},{"$f":"'Financial information '!$F$9*$E$2","v":2640}]
["Total Variable Expenses",{"$f":"SUM(B69:B70)","v":4488},{"$f":"SUM(C69:C70)","v":4488},{"$f":"SUM(D69:D70)","v":4488},4488,4488,4488,4488,4488,4488,4488,4488,4488]
["Expenses: due to lost sales"]
["Total  Expenses",{"$f":"B71+B66","v":17038},{"$f":"C71+C66","v":17038},{"$f":"D71+D66","v":17038},17038,17038,17038,17038,17038,17038,17038,17038,17038]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B62-B73+B57*G52-B58*$F$2","v":1267.0532959729026},{"$f":"C62-C73+C57*H52-C58*$F$2","v":5076.6963246926098},{"$f":"D62-D73+D57*I52-D58*$F$2","v":7138.9099406546375},8213.8761470788013,8222.8060679381197,11873.699122175876,5313.1230734099299,7056.3915913765086,6148.8505649351937,11939.951006788448,13845.735831610864,16119.646545520976,{"$f":"SUM(B75:M75)","v":102216.73951215486}]

{"sheet":"Expected Values Pt3","index":6,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[12,7,15,7],[46,2,46,4],[54,2,54,4],[2,2,2,4],[10,2,10,4],[17,2,17,4],[24,2,24,4],[31,2,31,4],[38,2,38,4]]}
[null,"PAYOFF TABLE"]
[]
[null,null,"State of Nature",null,null,null,null,"Summary of Results ","Methods "]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,{"$f":"B4","v":"Decision Alternatives"},"Maximin","MaxiMax","Laplace ","MinMax regret","EVUII","EOL"]
[null,"Continue as planned",{"$f":"AVERAGE('Current operations Pt2 & Pt3 '!B55:M55)","v":2805.2415239559718},{"$f":"AVERAGE('Current operations Pt2 & Pt3 '!B5:M5)","v":3790.866924264827},{"$f":"AVERAGE('Current operations Pt2 & Pt3 '!B30:M30)","v":4624.8576476030885},null,null,"Continue as planned",{"$f":"F13","v":2805.2415239559718},{"$f":"F20","v":4624.8576476030885},{"$f":"F27","v":3740.3220319412958},null,{"$f":"F42","v":3711.2587188552661},{"$f":"F58","v":3711.2587188552661}]
[null,"Join Franchise",{"$f":"AVERAGE('Franchise operations Pt2 & Pt3'!B55:M55)","v":3478.4994897054044},{"$f":"AVERAGE('Franchise operations Pt2 & Pt3'!B5:M5)","v":4700.6749860883847},{"$f":"AVERAGE('Franchise operations Pt2 & Pt3'!B30:M30)","v":5734.8234830278298},null,null,"Join Franchise",{"$f":"F14","v":3478.4994897054044},{"$f":"F21","v":5734.8234830278298},{"$f":"F28","v":4637.9993196072064},null,{"$f":"F43","v":4601.9608113805289},{"$f":"F59","v":4601.9608113805289}]
[null,null,null,null,null,null,null,"Decision Alternatives",{"$f":"I6","v":3478.4994897054044},{"$f":"J6","v":5734.8234830278298},4637.9993196072064,0,4601.9608113805289,{"$f":"N5","v":3711.2587188552661}]
[null,"DM UNDER IGNORANCE"]
[null,null,null,null,null,null,null,"Kiana should choose to:"]
[null,"Maximin",null,null,null,null,null,"join franchise"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","Min","Max","Because:"]
[null,"Continue as planned",{"$f":"$C$5","v":2805.2415239559718},{"$f":"$D$5","v":3790.866924264827},{"$f":"$E$5","v":4624.8576476030885},{"$f":"MIN(C13:E13)","v":2805.2415239559718},{"$f":"MAX(F13:F14)","v":3478.4994897054044},"more profits are earned when we buy franchise."]
[null,"Join Franchise",{"$f":"$C$6","v":3478.4994897054044},{"$f":"$D$6","v":4700.6749860883847},{"$f":"$E$6","v":5734.8234830278298},{"$f":"MIN(C14:E14)","v":3478.4994897054044}]
[]
[]
[null,"Maximax"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","Max","Max"]
[null,"Continue as planned",{"$f":"$C$5","v":2805.2415239559718},{"$f":"$D$5","v":3790.866924264827},{"$f":"$E$5","v":4624.8576476030885},{"$f":"MAX(C13:E13)","v":4624.8576476030885},{"$f":"MAX(F20:F21)","v":5734.8234830278298}]
[null,"Join Franchise",{"$f":"$C$6","v":3478.4994897054044},{"$f":"$D$6","v":4700.6749860883847},{"$f":"$E$6","v":5734.8234830278298},{"$f":"MAX(C14:E14)","v":5734.8234830278298}]
[]
[]
[null,"Laplace"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","Average","Max"]
[null,"Continue as planned",{"$f":"$C$5","v":2805.2415239559718},{"$f":"$D$5","v":3790.866924264827},{"$f":"$E$5","v":4624.8576476030885},{"$f":"AVERAGE(C27:E27)","v":3740.3220319412958},{"$f":"MAX(F27:F28)","v":4637.9993196072064}]
[null,"Join Franchise",{"$f":"$C$6","v":3478.4994897054044},{"$f":"$D$6","v":4700.6749860883847},{"$f":"$E$6","v":5734.8234830278298},{"$f":"AVERAGE(C28:E28)","v":4637.9993196072064}]
[]
[]
[null,"Minimax Regret"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","Max regret value","Min regret value"]
[null,"Continue as planned",{"$f":"$C$5","v":2805.2415239559718},{"$f":"$D$5","v":3790.866924264827},{"$f":"$E$5","v":4624.8576476030885},{"$f":"max","v":{"$error":"#NAME?"}}]
[null,"Join Franchise",{"$f":"$C$6","v":3478.4994897054044},{"$f":"$D$6","v":4700.6749860883847},{"$f":"$E$6","v":5734.8234830278298}]
[]
[null,"DM UNDER RISK"]
[null,"EVUII"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","Expected value","Max"]
[null,"Probability",0.25,0.55000000000000004,0.2]
[null,"Continue as planned",{"$f":"$C$5","v":2805.2415239559718},{"$f":"$D$5","v":3790.866924264827},{"$f":"$E$5","v":4624.8576476030885},{"$f":"C42*$C$41+D42*$D$41+E42*$E$41","v":3711.2587188552661},{"$f":"MAX(F42:F43)","v":4601.9608113805289}]
[null,"Join Franchise",{"$f":"$C$6","v":3478.4994897054044},{"$f":"$D$6","v":4700.6749860883847},{"$f":"$E$6","v":5734.8234830278298},{"$f":"C43*$C$41+D43*$D$41+E43*$E$41","v":4601.9608113805289}]
[]
[]
[null,"EVUPI"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","Expected value"]
[null,"Probability",0.25,0.55000000000000004,0.2]
[null,"payoff"]
[]
[null,"EVPI"]
[]
[null,"EOL"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","EOQ","Min"]
[null,"Probability",0.25,0.55000000000000004,0.2]
[null,"Continue as planned",{"$f":"$C$5","v":2805.2415239559718},{"$f":"$D$5","v":3790.866924264827},{"$f":"$E$5","v":4624.8576476030885},{"$f":"C58*$C$41+D58*$D$41+E58*$E$41","v":3711.2587188552661},{"$f":"MIN(F58:F59)","v":3711.2587188552661}]
[null,"Join Franchise",{"$f":"$C$6","v":3478.4994897054044},{"$f":"$D$6","v":4700.6749860883847},{"$f":"$E$6","v":5734.8234830278298},{"$f":"C59*$C$41+D59*$D$41+E59*$E$41","v":4601.9608113805289}]